Architecture of DBMS

DBMS architecture describes the structure and how the users are connected to a specific database system. Architecture affects the performance of the database. A Database Architecture is a representation of DBMS design

The architecture of DBMS is divided into three levels are as follows

1. Internal Level It is the lowest level of data abstraction that deals with the physical representation of the database on the computer. It is also known as physical level. It defines how the data are actually stored and organized on the storage medium.

2. Conceptual Level It is the overall view of the database and includes all the information that is going to be represented in the database. It describes what type of data is stored in the database, the relationship among the data without effecting to the physical level. It is also known as logical level.

3. External Level This is the highest level of data abstraction which describes the interaction between the user and the system.

It permits the users to access data in a way that is customized according to their needs, so that the same data can be seen by different users in different ways, at the same time. It is also known as view level.

Architecture of DBMS

DBMS architecture describes the structure and how the users are connected to a specific database system. Architecture affects the performance of the database. A Database Architecture is a representation of DBMS design

The architecture of DBMS is divided into three levels are as follows

1. Internal Level It is the lowest level of data abstraction that deals with the physical representation of the database on the computer. It is also known as physical level. It defines how the data are actually stored and organized on the storage medium.

2. Conceptual Level It is the overall view of the database and includes all the information that is going to be represented in the database. It describes what type of data is stored in the database, the relationship among the data without effecting to the physical level. It is also known as logical level.

3. External Level This is the highest level of data abstraction which describes the interaction between the user and the system.

It permits the users to access data in a way that is customized according to their needs, so that the same data can be seen by different users in different ways, at the same time. It is also known as view level.

In the Question:

The architecture of DBMS is divided into three levels are

The Answer is Physical,logical,External Level.

Hence the Option B is Correct.

Architecture of DBMS

DBMS architecture describes the structure and how the users are connected to a specific database system. Architecture affects the performance of the database. A Database Architecture is a representation of DBMS design. The architecture of DBMS is divided into three levels are as follows

1. Internal Level It is the lowest level of data abstraction that deals with the physical representation of the database on the computer. It is also known as physical level. It defines how the data are actually stored and organized on the storage medium.

2. Conceptual Level It is the overall view of the database and includes all the information that is going to be represented in the database. It describes what type of data is stored in the database, the relationship among the data without effecting to the physical level. It is also known as logical level.

3. External Level This is the highest level of data abstraction which describes the interaction between the user and the system.

It permits the users to access data in a way that is customized according to their needs, so that the same data can be seen by different users in different ways, at the same time. It is also known as view level.